package com.tl.control;

import java.util.Hashtable;
import java.util.List;

import org.apache.commons.lang.StringUtils;

import com.tl.util.JDBCUtils;


public class LotteryControl {

	/**
	 * 获取彩票分页数据
	 * @param pageIndex
	 * @return
	 */
	public List<Hashtable<String,Object>> getLotteryList(String pageIndex){
		int nPageIndex = 0;
		int nPageSize = 20;
		if(StringUtils.isNotEmpty(pageIndex)){
			nPageIndex = Integer.parseInt(pageIndex);
		}
		String sql = "select * from lottery limit "+nPageIndex*nPageSize+","+nPageSize+" ";
		return JDBCUtils.getQueryList(sql);
	}
	
	public void delLottery(String id){
		
		String sql = "delete table lottery where lId = ";
	}
	
}
